| Build |
| Definition | Identifies the version of the software that inserted/updated this row. |
| TouchedBy |
| Definition | The User who last updated the row. IDCode from CV3User table. |
| TouchedWhenUTC |
| Definition | Date and time the row was last updated. |
| CreatedBy |
| Definition | The User who created the row. IDCode from CV3User table. |
| CreatedWhenUTC |
| Definition | Date and time the row was created. |
| MSRowVersion |
| Definition | Optimistic lock identifier. |
| MSReplrowguid |
| Definition | Added in order to support Merge Replication. |
| Active |
| Definition | Active flag is used for soft deleting or deactivating rows from this table. |
| GUID |
| Definition | Primary key |
| MatchingWindowSessionGUID |
| Definition | Foreign key from SXAORMMedMatchingSessionsMaster |
| NEHRItemID |
| Definition | SCM created ID of the downloaded medication from NEHR |
| SCMItemID |
| Definition | FK from SXAORMMedMatchingSCMOrdersDetail |
| MedMatchingTypeID |
| Definition | Type of Medication match |
| FinalItemID |
| Definition | store new/modified order ID |
| ItemGroupKey |
| Definition | Group Info for the item |
| ItemSDDInfo |
| Definition | SDD Info for the item |
| ItemMLMInfo |
| Definition | MLM info for the item |
| FinalFromNEHRItemID |
| Definition | NEHR medication item ID |
| FinalFromSCMItemID |
| Definition | SCM medication item ID |